﻿CREATE TABLE [dbo].[tbl_order]
(
	[order_id] BIGINT NOT NULL PRIMARY KEY IDENTITY, 
    [name] NVARCHAR(256) NOT NULL, 
    [description] NVARCHAR(MAX) NULL, 
    [catalog_id] INT NULL, 
    [priсe] MONEY NULL, 
    [order_state_id] INT NULL, 
    [actual_date] DATE NULL, 
    [created] DATETIME NULL DEFAULT GETDATE(), 
    [key_word] NVARCHAR(128) NULL, 
    CONSTRAINT [FK_tbl_order_ToTable] FOREIGN KEY (order_state_id) REFERENCES [tbl_order_state]([state_id])
)

GO
